Creating 'Salary by Tenure' – 100% Stacked Column Chart 17
1. Chart Dimensions and Placement: From the
Visualizations pane, select the "100% Stacked Column Chart". Set the
chart dimensions to 332x384 and position it at Horizontal: 529,
Vertical: 387.
2. Chart Configuration: Set the
X-axis to "Tenure", reflecting the calculated field representing time
spent with the company, with values labeled in years (Yrs). Configure
the Y-axis for the count of "Salary", tallying different salary segments
within each tenure bracket.
3. Legend and Aesthetics:
Assign "Salary" as the legend to depict various salary bands within the stacked tenure columns. Disable the legend title for a cleaner appearance.
Disable the background to emphasize the chart data. Enable a visual border with the color #999999 for clear chart delineation.
Remove both the X-axis and Y-axis Titles to streamline the visual presentation. Since it's a 100% stacked chart, disable Y-axis values as they're redundant.
Adjust the X-axis values' color to #D0511A, applying the Segoe font at size 9 for clear legibility.
4. Formatting the Chart:
Update the chart title to "Salary by Tenure", set the font to DIN, size 14, align it in the middle, and apply a background color of #C7D4E8 for uniformity with the dashboard's design.
Designate column colors corresponding to salary levels: Low = #F1AE91, Medium = #EB8D64, High = #E66C37, for intuitive data understanding.
5. Data Labels:
Enable data labels and select "Percentage of total" for the value to
display inside each segment of the columns, facilitating an immediate
understanding of the distribution percentages within each tenure group.
6. Create 100% Stacked Column Chart for Predictive Section:
Following the same process, develop corresponding 100% Stacked Column
Chart for the predictive section, selecting appropriate predictive
measures and metrics for each chart. Ensure these also follow the
formatting standards and color schemes established in the historical
section for consistency.
7. Managing Visibility for Sections:
In the predictive section of the dashboard, select all historical charts and hide them using the Selection Pane. Then, update the predictive bookmark to save this state where only predictive charts are visible.
Conversely, in the historical section, hide all predictive charts through the Selection Pane and update the historical bookmark to reflect this setup, ensuring only historical charts display in this view. Finally, toggle between the historical and predictive bookmarks to verify the correct functionality and visibility of the charts.